package com.woniu.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.woniu.entity.dto.QueryOrderInfoDTO;
import com.woniu.entity.vo.OrderInfoVo;
import com.woniu.entity.vo.UserLoginVO;
import com.woniu.pojo.OrderInfo;
import org.apache.ibatis.annotations.ResultType;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface OrderInfoMapper extends BaseMapper<OrderInfo> {


    @Select("SELECT NAME,title,order_no,payment_type,total_fee,order_status,woi.create_time,woi.update_time FROM wnsys_order_info woi LEFT JOIN wnsys_user wu ON woi.user_id=wu.id;")
    @ResultType(OrderInfoVo.class)
    List<OrderInfoVo> listInfo();


    IPage<OrderInfoVo> searchPage(IPage<OrderInfoVo> page, QueryOrderInfoDTO queryOrderDTO);
}
